﻿CREATE TABLE [dbo].[ClientAddress] (
    [LoanID]             NVARCHAR (50)  NULL,
    [ClientType]         NVARCHAR (20)  NULL,
    [RelationToBorrower] NVARCHAR (20)  NULL,
    [Name]               NVARCHAR (101) NULL,
    [AddressType]        NVARCHAR (100) NULL,
    [AddressLine1]       NVARCHAR (255) NULL,
    [AddressLine2]       NVARCHAR (255) NULL,
    [City]               NVARCHAR (50)  NULL,
    [State]              NVARCHAR (20)  NULL,
    [ZipCode]            NVARCHAR (20)  NULL,
    [EffectiveDate]      DATETIME       NULL,
    [ExpirationDate]     DATETIME       NULL
);

